package com.gocoolmall.product.service.impl;

import com.alibaba.fastjson.TypeReference;
import com.gocoolmall.common.constant.ProductConstant;
import com.gocoolmall.common.to.SkuReductionTo;
import com.gocoolmall.common.to.SkuhasStockVo;
import com.gocoolmall.common.to.SpuBoundTo;
import com.gocoolmall.common.to.es.SkuEsModel;
import com.gocoolmall.common.utils.Query;
import com.gocoolmall.common.utils.R;
import com.gocoolmall.product.dao.SpuInfoDescDao;
import com.gocoolmall.product.entity.*;
import com.gocoolmall.product.feign.CouponFeignService;
import com.gocoolmall.product.feign.SearchFeignService;
import com.gocoolmall.product.feign.WareFeignService;
import com.gocoolmall.product.service.*;
import com.gocoolmall.product.vo.*;

import org.springframework.beans.BeanUtils;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import java.awt.*;
import java.math.BigDecimal;
import java.util.*;
import java.util.List;
import java.util.stream.Collectors;
import java.util.stream.Stream;

import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import com.gocoolmall.common.utils.PageUtils;

import com.gocoolmall.product.dao.SpuInfoDao;
import org.springframework.transaction.annotation.Transactional;
import org.springframework.util.StringUtils;


@Service("spuInfoService")
public class SpuInfoServiceImpl extends ServiceImpl<SpuInfoDao, SpuInfoEntity> implements SpuInfoService {

    @Autowired
    SpuInfoDescService spuInfoDescService;

    @Autowired
    SpuImagesService imagesService;

    @Autowired
    AttrService attrService;

    @Autowired
    ProductAttrValueService attrValueService;

    @Autowired
    SkuInfoService skuInfoService;

    @Autowired
    SkuImagesService skuImagesService;

    @Autowired
    SkuSaleAttrValueService skuSaleAttrValueService;

    @Autowired
    CouponFeignService couponFeignService;

    @Autowired
    BrandService brandService;

    @Autowired
    CategoryService categoryService;


    @Autowired
    WareFeignService wareFeignService;

    @Autowired
    SearchFeignService searchFeignService;

    @Override
    public PageUtils queryPage(Map<String, Object> params) {
        IPage<SpuInfoEntity> page = this.page(
                new Query<SpuInfoEntity>().getPage(params),
                new QueryWrapper<SpuInfoEntity>()
        );

        return new PageUtils(page);
    }

    /**
     * TODO
     * @param vo
     */
    //@GlobalTransactional  //seata AT分布式事务
    @Transactional  //事务
    @Override
    public void saveSpuInfo(SpuSaveVo vo) {
        //mysql 默认的可重复对
        //SET SESSION TRANSACTION ISOLATION LEVEL READ UNCOMMITTED   当前设置为读未提交
        //1、商品的基本信息：pms_spu_info
        SpuInfoEntity spuInfoEntity = new SpuInfoEntity();
        BeanUtils.copyProperties(vo,spuInfoEntity);
        spuInfoEntity.setCreateTime(new Date()); //创建时间
        spuInfoEntity.setUpdateTime(new Date());//更新时间
        this.savaBaseSpuInfo(spuInfoEntity);
        //2、保存spu的描述：pms_spu_info_desc
        List<String> decript = vo.getDecript();
        SpuInfoDescEntity descEntity = new SpuInfoDescEntity();
        descEntity.setSpuId(spuInfoEntity.getId());
        descEntity.setDecript(String.join(",",decript));
        spuInfoDescService.savaSpuInfoDesc(descEntity);

        //3、保存spu的图片集：pms_spu_images
        List<String> images = vo.getImages();
        imagesService.saveImage(spuInfoEntity.getId(),images);

        //4、保存spu的规格参数：pms_product_attr_value
        List<BaseAttrs> baseAttrs = vo.getBaseAttrs();
        List<ProductAttrValueEntity> collect = baseAttrs.stream().map(attr -> {
            ProductAttrValueEntity attrValueEntity = new ProductAttrValueEntity();
            attrValueEntity.setAttrId(attr.getAttrId());
            AttrEntity attrEntity = attrService.getById(attr.getAttrId());
            attrValueEntity.setAttrName(attrEntity.getAttrName());
            attrValueEntity.setAttrValue(attr.getAttrValues());
            attrValueEntity.setQuickShow(attr.getShowDesc());
            attrValueEntity.setSpuId(spuInfoEntity.getId());
            return attrValueEntity;
        }).collect(Collectors.toList());
        attrValueService.savaProductAttr(collect);
        /**
         * 跨库
         */
        //5、商品积分：gocoolmall_sms库中下的sms_spu_bounds商品的积分表
        Bounds bounds = vo.getBounds();
        SpuBoundTo spuBoundTo = new SpuBoundTo();
        BeanUtils.copyProperties(bounds,spuBoundTo);
        spuBoundTo.setSpuId(spuInfoEntity.getId());
        R r1 = couponFeignService.saveSpuBounds(spuBoundTo);
        if (r1.getCode() != 0){
            log.error("远程保存spu积分信息失败");
        }

        //6、保存当前spu对应的所有sku信息
        List<Skus> skus = vo.getSkus();
        if (skus != null && skus.size() >0){
            skus.forEach(item ->{
                String defaultImg = "";
                for (Images image:item.getImages()){
                    if (image.getDefaultImg() == 1){
                        defaultImg = image.getImgUrl();
                    }
                }
                SkuInfoEntity skuInfoEntity = new SkuInfoEntity();
                BeanUtils.copyProperties(item,skuInfoEntity);
                skuInfoEntity.setBrandId(spuInfoEntity.getBrandId());
                skuInfoEntity.setCatalogId(spuInfoEntity.getCatalogId());
                skuInfoEntity.setSaleCount(0L);
                skuInfoEntity.setSpuId(spuInfoEntity.getId());
                skuInfoEntity.setSkuDefaultImg(defaultImg);
        //6.1）sku的基本信息:pms_sku_info
                skuInfoService.saveSkuInfo(skuInfoEntity);

                Long skuId = skuInfoEntity.getSkuId();

                List<SkuImagesEntity> skuImagesEntities = item.getImages().stream().map(img -> {
                    SkuImagesEntity skuImagesEntity = new SkuImagesEntity();
                    skuImagesEntity.setSkuId(skuId);
                    skuImagesEntity.setImgUrl(img.getImgUrl());
                    skuImagesEntity.setDefaultImg(img.getDefaultImg());
                    return skuImagesEntity;
                }).filter(entity ->{
                    // todo没有图片路径的不保存  返回true就是需要，返回false就是提出。
                    return !StringUtils.isEmpty(entity.getImgUrl());
                }).collect(Collectors.toList());
        //6.2）sku的图片信息：pms_sku_images

                skuImagesService.saveBatch(skuImagesEntities);

        //6.3) sku的销售属性信息：pms_sku_sale_attr_value
                List<Attr> attr = item.getAttr();
                List<SkuSaleAttrValueEntity> skuSaleAttrValueEntities = attr.stream().map(a -> {
                    SkuSaleAttrValueEntity saleAttrValueEntity = new SkuSaleAttrValueEntity();
                    BeanUtils.copyProperties(a, saleAttrValueEntity);
                    saleAttrValueEntity.setSkuId(skuId);
                    return saleAttrValueEntity;
                }).collect(Collectors.toList());
                skuSaleAttrValueService.saveBatch(skuSaleAttrValueEntities);
                /**
                 * 跨库
                 */
                //6.4） sku的优惠、满减信息：gocoolmall_sms库中
                //6.4.1)sku的优惠、满减信息：gocoolmall_sms库中下的sms_sku_ladder打折表
                SkuReductionTo skuReductionTo = new SkuReductionTo();
                BeanUtils.copyProperties(item,skuReductionTo);
                skuReductionTo.setSkuId(skuId);
                if (skuReductionTo.getFullCount()  > 0 || skuReductionTo.getFullPrice().compareTo(new BigDecimal("0")) == 1 ) {
                    R r = couponFeignService.saveSkuReduction(skuReductionTo);
                    if (r.getCode() != 0) {
                        log.error("远程保存sku优惠信息失败");
                    }
                }

                //6.4.2)sku的优惠、满减信息：gocoolmall_sms库中下的sms_sku_full_reduction满减表
                //6.4.3)sku的优惠、满减信息：gocoolmall_sms库中下的sms_member_price会员价格表

            });
        }

    }

    @Override
    public void savaBaseSpuInfo(SpuInfoEntity spuInfoEntity) {
        this.baseMapper.insert(spuInfoEntity);
    }

    @Override
    public PageUtils queryBaseSpuInfo(Map<String, Object> params) {
        QueryWrapper<SpuInfoEntity> wrapper = new QueryWrapper<>();

        String key = (String) params.get("key");
        if (!StringUtils.isEmpty(key)){
            wrapper.and((w) ->{w.eq("id",key).or().like("spu_name",key);
            });
        }

        String status = (String) params.get("status");
        if (!StringUtils.isEmpty(status)){
            wrapper.eq("publish_status",status);
        }
        String brandId = (String) params.get("brandId");
        if (!StringUtils.isEmpty(brandId) && !"0".equalsIgnoreCase(brandId)){
            wrapper.eq("brand_id",brandId);
        }

        String catelogId = (String) params.get("catelogId");
        if (!StringUtils.isEmpty(catelogId) && !"0".equalsIgnoreCase(catelogId)){
            wrapper.eq("catalog_id",catelogId);
        }

        IPage<SpuInfoEntity> page = this.page(new Query<SpuInfoEntity>().getPage(params), wrapper);



        return new PageUtils(page);
    }

    @Override
    public void up(Long spuId) {
        ArrayList<SkuEsModel> uoProducts = new ArrayList<>();
        //1、组装需要的数据
        SkuEsModel skuEsModel = new SkuEsModel();
        //1.1 查出当前spuid对应的所有sku信息，品牌的名字。
        List<SkuInfoEntity> skus=skuInfoService.getSkuBySpuId(spuId);
        List<Long> skuIdList = skus.stream().map(SkuInfoEntity::getSkuId).collect(Collectors.toList());

        //TODO 4、查询当前sku的所有可以用来检索的规格属性
        List<ProductAttrValueEntity> baseAttrs=attrValueService.baseAttrlistforspu(spuId);
        List<Long> attrIds = baseAttrs.stream().map(attr -> {
            return attr.getAttrId();
        }).collect(Collectors.toList());

        List<Long> searchAttrIds = attrService.selectSearchAttrs(attrIds);
        Set idSet = new HashSet<>(searchAttrIds);
        List<SkuEsModel.Attrs> attrs = new ArrayList<>();
        List<SkuEsModel.Attrs> attrsList = baseAttrs.stream().filter(item -> {
            return idSet.contains(item.getAttrId());
        }).map(item ->{
            SkuEsModel.Attrs attrs1 = new SkuEsModel.Attrs();
            BeanUtils.copyProperties(item,attrs1);
            return attrs1;
        }).collect(Collectors.toList());

        // TODO 1、发动远程调用，库存系统查询是否有库存
        Map<Long, Boolean> stockMap = null;
        try {
            R r = wareFeignService.getSkuHasStock(skuIdList);
            TypeReference<List<SkuhasStockVo>> typeReference = new TypeReference<List<SkuhasStockVo>>() {
            };
            stockMap = r.getDate(typeReference).stream().collect(Collectors.toMap(SkuhasStockVo::getSkuId, item -> item.getHasStock()));
        } catch (Exception e) {
            e.printStackTrace();
            log.error("库存服务查询异常：原因{}",e);
        }

        //1.2封装每个sku的信息
        Map<Long, Boolean> finalStockMap = stockMap;
        List<SkuEsModel> upProduct = skus.stream().map(sku -> {
            //组装需要的数据
            SkuEsModel esModel = new SkuEsModel();
            BeanUtils.copyProperties(sku, esModel);
            esModel.setSkuPrice(sku.getPrice());
            esModel.setSkuImg(sku.getSkuDefaultImg());
            //1、发送远程调用，库存系统查询是否有库存
            if (finalStockMap == null) {
                esModel.setHasStock(true);
            } else {
                esModel.setHasStock(finalStockMap.get(sku.getSkuId()));
            }

            //TODO 2、热度评分，0
            esModel.setHotScore(0L);

            //TODO 3、查询品牌合分类的名字信息
            BrandEntity brand = brandService.getById(esModel.getBrandId());
            esModel.setBrandImg(brand.getLogo());
            esModel.setBrandName(brand.getName());

            CategoryEntity category = categoryService.getById(esModel.getCatalogId());
            esModel.setCatalogName(category.getName());

            //4、设置检索属性
            esModel.setAttrs(attrsList);

            return esModel;
        }).collect(Collectors.toList());

        //TODO 5、将数据发送给es进行保存；gocoolmall-search
        R r = searchFeignService.productStatusUp(upProduct);
        if (r.getCode()  == 0){
            //远程调用成功
            //TODO 6、修改当前spu的状态
            this.baseMapper.updateSpuStatus(spuId, ProductConstant.StatusEnum.SPU_UP.getCode());
        }else {
            //TODO 7、重复调用？接口幂等性；重试机制？xxx
            /**
             * 1、构造请求数据，将对象转化为json
             *
             * 2、发送请求进行执行。
             *
             * 3、执行请求会有重试机制
             */
        }

    }

    @Override
    public SpuInfoEntity getSpuInfoBySkuId(Long skuId) {
        SkuInfoEntity byId = skuInfoService.getById(skuId);
        System.out.println("SkuInfoEntity::"+byId);
        Long spuId = byId.getSpuId();
        System.out.println("spuId::"+spuId);
        SpuInfoEntity spuInfoEntity = getById(spuId);
        System.out.println("SpuInfoEntity::"+spuInfoEntity);
        return spuInfoEntity;
    }


}